To Configure the SSRS SQL Server Component on the Web Server
SSRS requires that IIS APPPOOLDefaultAppPool have additional privileges. If this is not configured, this error appears when you select any hosted report:
The permissions granted to user 'IIS APPPOOLDefaultAppPool' are insufficient for performing this operation. (rsAccessDenied)
- From the Start menu, open the Internet Information Services (IIS) Manager.
- In the Connections pane, click Application Pools.
- In the Application Pools pane (right), double-click DefaultAppPool. The Edit Application Pool dialog opens. The Name field is not editable.
- Set the following fields as below:
- Click OK to close the Edit Application Pool dialog.
- In the Application Pools pane, right-click DefaultAppPool and select Advanced Settings. The Advanced Settings dialog opens.
- In the Process Model section, click the browse button on the Identity field. The Application Pool Identity dialog opens.
- Select Custom account and click Set. The Set Credentials dialog opens.
- Add the User name and password and confirm the password. The custom account information displays in the Identify field.
- In the Process Model section, click the drop down button in the Load User Profile field and set this option to True.
- Click OK to close the Advanced Settings dialog.